<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/cloudiary.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>CloudDiary</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<script type="text/javascript" src="Js/jquery-1.3.1.min.js"></script>	

<script type="text/javascript" language="javascript" src="Js/slider.js"></script>

<script type="text/javascript" language="javascript" src="Js/jquery.js"></script>
<!-- InstanceEndEditable -->
<link href="CSS/css.css" rel="stylesheet" type="text/css" />
</head>
<?php
include('userlock.php');

$single_page=5;
$test = "SELECT DISTINCT u.user_name, u.user_email, p.post_topic,p.post,p.post_date,p.post_time,p.post_edit_date,p.post_edit_time,p.privacy_type,p.post_ID FROM post p INNER JOIN user u ON p.user_email = u.user_email Where ((p.user_email) NOT IN (SELECT f.friend_email FROM Friend f Where f.user_email = '$login_session') AND (p.user_email != '$login_session')) AND p.privacy_type = 'public'";
$query_name=mysql_query($test);
    
$count=mysql_num_rows($query_name);
$total_pages=ceil($count/$single_page);

if(isset($_GET['page']) && is_numeric($_GET['page']))
{
    $obtain_page=$_GET['page'];
    if($obtain_page>0 && $obtain_page<=$total_pages)
    {
		$starting_page=($obtain_page-1)*$single_page;
        $ending_page=$starting_page+$single_page;
    }
    else
    {
        $starting_page=0;
        $ending_page=$starting_page+$single_page;
    }
}
else
{
    $starting_page=0;
    $ending_page=$starting_page+$single_page;
}        
?>

<?php
$test2 = $test. " LIMIT $starting_page,$single_page";
$q=mysql_query($test2);

?>
<body>
<div id="container">
<div id="wrapper">

<div id="header">
<!-- InstanceBeginEditable name="header" -->
<div class="welcome">
<?php include('welcomeuser.php');?>
</div>
<!-- InstanceEndEditable -->

<img src="Assets/cloud diary low-01(trans).png" alt="CloudDiary" width="75" height="45" style="padding:5px 10px;" /> <br />
</div>

<div id="main">
<!-- InstanceBeginEditable name="main" -->
<ul class="dropdown">
<li><a href="Home.php" class="linkStraight">Home &nbsp; &nbsp;</a></li>
<li><a href="#" class="linkDown" id="classification">Classifications &nbsp; &nbsp;</a>
	<ul class="sub_menu" id="menu1">
    <li> <a href="PublicClassification.php"> Public &nbsp; </a> </li>
    <li> <a href="FriendClassification.php"> Friend &nbsp; </a> </li>
    </ul>
</li>
<li><a href="#" class="linkDown" id="friends">Friends &nbsp; &nbsp;</a>
	<ul class="sub_menu" id="menu2">
    <li> <a href="Friends.php"> Search Friends &nbsp; </a> </li>
    <li> <a href="CurrentFriends.php"> Current Friends &nbsp; </a> </li>
    <li> <a href="Send.php"> Sending Request &nbsp; </a> </li>
    <li> <a href="Receive.php"> Pending Request &nbsp; </a> </li>
    </ul>
</li>
<li><a href="#" class="linkDown" id="posts">Posts &nbsp; &nbsp;</a>
	<ul class="sub_menu" id="menu3">
    <li> <a href="NewPost.php"> New Post &nbsp; </a> </li>
    <li> <a href="ViewPosts.php">  View All Posts &nbsp; </a> </li>
    </ul>
</li>
<li><a href="Privacy.php" class="linkStraight">Privacy Settings &nbsp; &nbsp;</a></li>
</ul>

<div id="content">
<div id="page">
<?php
echo"<p><strong>Page: &nbsp;</strong>";
for($a=1;$a<=$total_pages;$a++)
{
    echo"<a href='FriendClassification.php?page=$a'>$a</a>"." | ";
}
?>
</div>
<?php
echo"</p>";
?>

<?php
for($a=$starting_page;$a<$ending_page;$a++)
    {
      if($a==$count){
      break;
      }
      
      while($data_fetch=mysql_fetch_array($q))
      { 	  
		echo "<div class='classification'>";
		echo "<table border='0' width='100%'>";
		echo "<tr> <td width='90' rowspan='2' style='border:solid 1px #69F; padding:2px;' align='center'>";
		echo "<img src='display_photo.php?id=".$data_fetch['user_email']."' width='90px' height='100px' />";
		echo "</td>";
		echo "<td rowspan='2' width='20' style='border-right:solid 1px #69F'> &nbsp; </td>";
		echo "<td colspan='4'> <p style='font-size:16px;font-weight:bold; padding-left:8px;'> Topic: ".$data_fetch['post_topic']." </p>";
		echo "<p style='padding-left:8px;'> ".substr($data_fetch['post'], 0, 300)." <br /> <a href='FriendPost.php?id=".$data_fetch['post_ID']."'> Read More &raquo; </a>";
		echo "</p> </td>";
		echo "</tr> <tr>";
		echo "<td height='20px' align='center' style='color:#999; font-size:11px'> Posted By ".$data_fetch['user_name']."</td>";
		echo "<td height='20px' align='center' style='color:#999; font-size:11px'> Posted On ".$data_fetch['post_time']."</td>";
		echo "<td height='20px' align='center' style='color:#999; font-size:11px'> Posted Date ".$data_fetch['post_date']."</td>";
		echo "<td height='20px' align='center' style='color:#999; font-size:11px'> Last Update on ".$data_fetch['post_edit_time']." &nbsp; &nbsp; ".$data_fetch['post_edit_date']."</td>";
		echo "</tr> </table>";
		echo "</div>";		
      }
    }    
  ?>

</div>
<!-- InstanceEndEditable -->
</div>

</div>
</div>

<div id="footer">
<p align="center"> &copy; &nbsp; 2012 CloudDiary </p>
</div>
</body>
<!-- InstanceEnd --></html>
